import java.sql.*; 
public class Example11_3 {
	   public static void main(String args[]) {
		         Connection con;
			       Statement sql; 
			             ResultSet rs;
				           con = GetDBConnection.connectDB("students","root","");
					         if(con == null ) return;
						       String c1=" year(birthday)<=2000 and month(birthday)>7";//条件1
						             String c2=" name Like '张_%'";
							           String c3=" height >1.65";
								         String sqlStr =
										       "select * from mess where "+c1+" and "+c2+" and "+c3+"order by birthday";
									       try { 
										                 sql=con.createStatement();
												           rs = sql.executeQuery(sqlStr);
													             while(rs.next()) { 
															                  String number=rs.getString(1);
																	               String name=rs.getString(2);
																		                    Date date=rs.getDate(3);
																				                 float height=rs.getFloat(4);
																						              System.out.printf("%s\t",number);
																							                   System.out.printf("%s\t",name);
																									                System.out.printf("%s\t",date); 
																											             System.out.printf("%.2f\n",height);
																												               }
														               con.close();
															             }
									             catch(SQLException e) { 
											              System.out.println(e);
												            }
										       }
}

